ER図をSQL文に変換するオープンソースソフトウェア(OSS)について、以下のツールが便利です。
dbdiagram.ioは、ER図の作成とSQLスクリプトへの変換をサポートするウェブベースのツールです。MermaidやPlantUMLのようなシンプルなテキスト記法でER図を描くことができ、その図を基にSQL文を生成することができます。
特徴
- テキストベースのER図記法
- SQLスクリプトの自動生成
- ダイアグラムの共有とコラボレーション機能
| """ | |
| The most atomic way to train and inference a GPT in pure, dependency-free Python. | |
| This file is the complete algorithm. | |
| Everything else is just efficiency. | |
| @karpathy | |
| """ | |
| import os # os.path.exists | |
| import math # math.log, math.exp |
| SQL Server 2017 | |
| ---------------- | |
| Enterprise Core - 6GPYM-VHN83-PHDM2-Q9T2R-KBV83 | |
| Developer - 22222-00000-00000-00000-00000 | |
| Enterprise - TDKQD-PKV44-PJT4N-TCJG2-3YJ6B | |
| Standard - PHDV4-3VJWD-N7JVP-FGPKY-XBV89 | |
| Web - WV79P-7K6YG-T7QFN-M3WHF-37BXC | |
| https://www.teamos-hkrg.com/index.php?threads/microsoft-sql-server-english-2017-rtm-teamos.42103/ |
For many years, I've used Picasa to manage my thousands of photos. I'm not a pro, so I shoot in JPG instead of RAW, and Picasa offered the things I needed: basic tag management, some basic non-destructive photo editing, and a star label to indicate which photos I had uploaded to my online albums.
I recently decided to move everything into digiKam, which meets all of my requirements and gives me room to expand my workflow. Getting my photos and stars into digiKam required a little bit of elbow grease, and I thought I'd share my process and the scripts I wrote. All of the scripts below are in C# and were run with LINQPad. Note that I'm on Windows, so things might need to be adjusted a bit for other OSes. (And LINQPad is Windows only, but the scripts should also run as C# apps.)
Because I had made use of Picasa's non-destructive editing, all of my original photos on disk were
| { | |
| "ver":"5.0", | |
| "tag":"hipsuser", | |
| "data":[ | |
| { | |
| "id":54, | |
| "power":1, | |
| "name":"禁垃圾软件", | |
| "procname":"*", | |
| "treatment":3, |